In a similar to fashion to how Haunting Ground is very intense, Rule of Rose is very psychologically horrifying and has it all happen to children, basically.
The game follows a nineteen year old woman named Jennifer, who gets off at a bus stop, wonders into the woods, and comes across an orphanage.
All the abuse that Jennifer is subject to is inflicted, primarily, by children (little girls in charge of something called the Red Crayon Aristocrat Club
There's chilc on child abuse as well, through lots of teasing, shaming, and mental torture - basically. The children are ROUGH in this game.
Jennifer's dog, a good boy named Brown, does eventually die. It's quite cruel and done by children. It's not explicit, but it does happen (and is done by the person you'd least expect!)
There is mention of sexual abuse against a child, a girl named Clara I believe, and while it's not explicit it is still there and upsetting.
There is a good ending where Jennifer accepts what happened to her at the orphanage, and accepts Brown's death, and a bad ended where she represses it all and never gets over it.
Ultimately, Rule of Rose is a very beautiful game that will stick with you, but it's extremely heavy with certain topics and should be avoided if one is sensitive to anything mentioned here.